Rob Hagan ✭✭✭

Overview

Overview

Roles	Member
Badges	22

About Me

About Me

Area of Expertise	Formulas
About Me	http://www.fenton.com.au/passion/
How I Use Smartsheet	Extensive use in costing of project proposals and in project management (for project managers and team members).

Analytics

80

Posts

70

Visits

149

Points

Apr 11, 2016

Join Date

Sep 8, 2023

Last Active

Reactions

• Insightful 1

  1
• Vote Up 29

  29
• Awesome 1

  1

• Activity
• Discussions10
• Comments70

• Row number

  Rob Hagan

  07/18/18
  Hi Thrill Seekers, I am seeking a way to access the row number of a row in a sheet. I would be very happy if this came in the form of a SmartSheet function (let's call it Row) so that I could create …
  1 ·

• Ability to “freeze” the Gantt Chart Bar

  Rob Hagan

  12/06/22
  When a sheet is showing the Gantt Chart and you open the Sheet Summary, the left side of the Gantt Chart is pushed left to make room for the Sheet Summary. When you close the Sheet Summary the left s…
  3 ·

• Re: Why are unlicensed users asked to upgrade to Premium?

  Rob Hagan

  07/09/20
  It is probably worth noting that they are members of our Account with user-ids on our Domain. In Smartsheet terms they only need to be "collaborators" and don't need to be licensed users.
  3 ·

• Re: Formula to determine row number

  Rob Hagan

  12/13/16
  Hi Fred, There is, provided that you are OK using two columns to achieve the outcome. Let's assume that we have two columns at our disposal named Column2 and Column3. In the first row of Column2 put …
  4 ·

• Re: Why does SS not have a Text Function that allows numbers to be converted into Text? So simply.

  Rob Hagan

  07/08/20
  Where you know that the number will always be between 0 and 99 then =IF(Number@row < 10, "0", "") + Number@row Where you know that the number will always be between 0 and 999 t…
  1 ·

Next